1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="MainDBDataSet" targetNamespace="http://tempuri.org/MainDBDataSet.xsd" xmlns:mstns="http://tempuri.org/MainDBDataSet.xsd" xmlns="http://tempuri.org/MainDBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="MainDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MainDBConnectionString (MySettings)" PropertyReference="ApplicationSettings.ExaminationSystem.My.MySettings.GlobalReference.Default.MainDBConnectionString" Provider="System.Data.OleDb" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AdminTableAdapter" GeneratorDataComponentClassName="AdminTableAdapter" Name="Admin" UserDataComponentName="AdminTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="MainDBConnectionString (MySettings)" DbObjectName="Admin" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM `Admin` WHERE ((`ID` = ?) AND ((? = 1 AND `Mobile` IS NULL) OR (`Mobile` = ?)) AND ((? = 1 AND `Email` IS NULL) OR (`Email` = ?)) AND ((? = 1 AND `Pass` IS NULL) OR (`Pass` = ?)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Mobile" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Mobile" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Mobile" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Email" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Pass" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Pass" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="false" SourceVersion="Original" />
24 </Parameters>
25 </DbCommand>
26 </DeleteCommand>
27 <InsertCommand>
28 <DbCommand CommandType="Text" ModifiedByUser="false">
29 <CommandText>INSERT INTO `Admin` (`ID`, `Full Name`, `Subject`, `Mobile`, `Email`, `Pass`) VALUES (?, ?, ?, ?, ?, ?)</CommandText>
30 <Parameters>
31 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
32 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Full_Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Full Name" SourceColumnNullMapping="false" SourceVersion="Current" />
33 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Subject" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
34 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mobile" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile" SourceColumnNullMapping="false" SourceVersion="Current" />
35 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
36 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Pass" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="false" SourceVersion="Current" />
37 </Parameters>
38 </DbCommand>
39 </InsertCommand>
40 <SelectCommand>
41 <DbCommand CommandType="Text" ModifiedByUser="false">
42 <CommandText>SELECT ID, [Full Name], Subject, Mobile, Email, Pass FROM Admin</CommandText>
43 <Parameters />
44 </DbCommand>
45 </SelectCommand>
46 <UpdateCommand>
47 <DbCommand CommandType="Text" ModifiedByUser="false">
48 <CommandText>UPDATE `Admin` SET `ID` = ?, `Full Name` = ?, `Subject` = ?, `Mobile` = ?, `Email` = ?, `Pass` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Mobile` IS NULL) OR (`Mobile` = ?)) AND ((? = 1 AND `Email` IS NULL) OR (`Email` = ?)) AND ((? = 1 AND `Pass` IS NULL) OR (`Pass` = ?)))</CommandText>
49 <Parameters>
50 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
51 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Full_Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Full Name" SourceColumnNullMapping="false" SourceVersion="Current" />
52 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Subject" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
53 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mobile" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile" SourceColumnNullMapping="false" SourceVersion="Current" />
54 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
55 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Pass" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="false" SourceVersion="Current" />
56 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Mobile" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Mobile" SourceColumnNullMapping="true" SourceVersion="Original" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Mobile" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile" SourceColumnNullMapping="false" SourceVersion="Original" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Email" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
60 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
61 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Pass" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="true" SourceVersion="Original" />
62 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Pass" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="false" SourceVersion="Original" />
63 </Parameters>
64 </DbCommand>
65 </UpdateCommand>
66 </DbSource>
67 </MainSource>
68 <Mappings>
69 <Mapping SourceColumn="ID" DataSetColumn="ID" />
70 <Mapping SourceColumn="Full Name" DataSetColumn="Full Name" />
71 <Mapping SourceColumn="Subject" DataSetColumn="Subject" />
72 <Mapping SourceColumn="Mobile" DataSetColumn="Mobile" />
73 <Mapping SourceColumn="Email" DataSetColumn="Email" />
74 <Mapping SourceColumn="Pass" DataSetColumn="Pass" />
75 </Mappings>
76 <Sources />
77 </TableAdapter>
78 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StudentTableAdapter" GeneratorDataComponentClassName="StudentTableAdapter" Name="Student" UserDataComponentName="StudentTableAdapter">
79 <MainSource>
80 <DbSource ConnectionRef="MainDBConnectionString (MySettings)" DbObjectName="Student" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
81 <DeleteCommand>
82 <DbCommand CommandType="Text" ModifiedByUser="false">
83 <CommandText>DELETE FROM `Student` WHERE ((`RollNo` = ?) AND ((? = 1 AND `Dept` IS NULL) OR (`Dept` = ?)) AND ((? = 1 AND `Current Year` IS NULL) OR (`Current Year` = ?)) AND ((? = 1 AND `Mob` IS NULL) OR (`Mob` = ?)) AND ((? = 1 AND `Email` IS NULL) OR (`Email` = ?)) AND ((? = 1 AND `Password` IS NULL) OR (`Password` = ?)) AND ((? = 1 AND `Test Date` IS NULL) OR (`Test Date` = ?)) AND ((? = 1 AND `Total_Ques` IS NULL) OR (`Total_Ques` = ?)) AND ((? = 1 AND `hour` IS NULL) OR (`hour` = ?)) AND ((? = 1 AND `min` IS NULL) OR (`min` = ?)) AND ((? = 1 AND `sec` IS NULL) OR (`sec` = ?)))</CommandText>
84 <Parameters>
85 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RollNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RollNo" SourceColumnNullMapping="false" SourceVersion="Original" />
86 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Dept" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Dept" SourceColumnNullMapping="true" SourceVersion="Original" />
87 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Dept" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Dept" SourceColumnNullMapping="false" SourceVersion="Original" />
88 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Current_Year" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Current Year" SourceColumnNullMapping="true" SourceVersion="Original" />
89 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Current_Year" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Current Year" SourceColumnNullMapping="false" SourceVersion="Original" />
90 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Mob" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Mob" SourceColumnNullMapping="true" SourceVersion="Original" />
91 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Mob" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mob" SourceColumnNullMapping="false" SourceVersion="Original" />
92 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Email" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
93 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
94 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Password" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
95 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
96 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Test_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Test Date" SourceColumnNullMapping="true" SourceVersion="Original" />
97 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Test_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Test Date" SourceColumnNullMapping="false" SourceVersion="Original" />
98 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Total_Ques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Total_Ques" SourceColumnNullMapping="true" SourceVersion="Original" />
99 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Total_Ques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Total_Ques" SourceColumnNullMapping="false" SourceVersion="Original" />
100 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_hour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="hour" SourceColumnNullMapping="true" SourceVersion="Original" />
101 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_hour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="hour" SourceColumnNullMapping="false" SourceVersion="Original" />
102 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_min" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="min" SourceColumnNullMapping="true" SourceVersion="Original" />
103 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_min" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="min" SourceColumnNullMapping="false" SourceVersion="Original" />
104 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_sec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sec" SourceColumnNullMapping="true" SourceVersion="Original" />
105 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sec" SourceColumnNullMapping="false" SourceVersion="Original" />
106 </Parameters>
107 </DbCommand>
108 </DeleteCommand>
109 <InsertCommand>
110 <DbCommand CommandType="Text" ModifiedByUser="false">
111 <CommandText>INSERT INTO `Student` (`RollNo`, `Full Name`, `Dept`, `Current Year`, `Mob`, `Email`, `Password`, `Test Date`, `Total_Ques`, `hour`, `min`, `sec`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
112 <Parameters>
113 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RollNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RollNo" SourceColumnNullMapping="false" SourceVersion="Current" />
114 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Full_Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Full Name" SourceColumnNullMapping="false" SourceVersion="Current" />
115 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dept" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Dept" SourceColumnNullMapping="false" SourceVersion="Current" />
116 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Current_Year" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Current Year" SourceColumnNullMapping="false" SourceVersion="Current" />
117 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mob" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mob" SourceColumnNullMapping="false" SourceVersion="Current" />
118 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
119 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
120 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Test_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Test Date" SourceColumnNullMapping="false" SourceVersion="Current" />
121 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Total_Ques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Total_Ques" SourceColumnNullMapping="false" SourceVersion="Current" />
122 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="hour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="hour" SourceColumnNullMapping="false" SourceVersion="Current" />
123 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="min" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="min" SourceColumnNullMapping="false" SourceVersion="Current" />
124 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="sec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sec" SourceColumnNullMapping="false" SourceVersion="Current" />
125 </Parameters>
126 </DbCommand>
127 </InsertCommand>
128 <SelectCommand>
129 <DbCommand CommandType="Text" ModifiedByUser="false">
130 <CommandText>SELECT RollNo, [Full Name], Dept, [Current Year], Mob, Email, [Password], [Test Date], Total_Ques, [hour], [min], sec FROM Student</CommandText>
131 <Parameters />
132 </DbCommand>
133 </SelectCommand>
134 <UpdateCommand>
135 <DbCommand CommandType="Text" ModifiedByUser="false">
136 <CommandText>UPDATE `Student` SET `RollNo` = ?, `Full Name` = ?, `Dept` = ?, `Current Year` = ?, `Mob` = ?, `Email` = ?, `Password` = ?, `Test Date` = ?, `Total_Ques` = ?, `hour` = ?, `min` = ?, `sec` = ? WHERE ((`RollNo` = ?) AND ((? = 1 AND `Dept` IS NULL) OR (`Dept` = ?)) AND ((? = 1 AND `Current Year` IS NULL) OR (`Current Year` = ?)) AND ((? = 1 AND `Mob` IS NULL) OR (`Mob` = ?)) AND ((? = 1 AND `Email` IS NULL) OR (`Email` = ?)) AND ((? = 1 AND `Password` IS NULL) OR (`Password` = ?)) AND ((? = 1 AND `Test Date` IS NULL) OR (`Test Date` = ?)) AND ((? = 1 AND `Total_Ques` IS NULL) OR (`Total_Ques` = ?)) AND ((? = 1 AND `hour` IS NULL) OR (`hour` = ?)) AND ((? = 1 AND `min` IS NULL) OR (`min` = ?)) AND ((? = 1 AND `sec` IS NULL) OR (`sec` = ?)))</CommandText>
137 <Parameters>
138 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RollNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RollNo" SourceColumnNullMapping="false" SourceVersion="Current" />
139 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Full_Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Full Name" SourceColumnNullMapping="false" SourceVersion="Current" />
140 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dept" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Dept" SourceColumnNullMapping="false" SourceVersion="Current" />
141 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Current_Year" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Current Year" SourceColumnNullMapping="false" SourceVersion="Current" />
142 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mob" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mob" SourceColumnNullMapping="false" SourceVersion="Current" />
143 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
144 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
145 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Test_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Test Date" SourceColumnNullMapping="false" SourceVersion="Current" />
146 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Total_Ques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Total_Ques" SourceColumnNullMapping="false" SourceVersion="Current" />
147 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="hour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="hour" SourceColumnNullMapping="false" SourceVersion="Current" />
148 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="min" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="min" SourceColumnNullMapping="false" SourceVersion="Current" />
149 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="sec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sec" SourceColumnNullMapping="false" SourceVersion="Current" />
150 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RollNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RollNo" SourceColumnNullMapping="false" SourceVersion="Original" />
151 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Dept" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Dept" SourceColumnNullMapping="true" SourceVersion="Original" />
152 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Dept" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Dept" SourceColumnNullMapping="false" SourceVersion="Original" />
153 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Current_Year" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Current Year" SourceColumnNullMapping="true" SourceVersion="Original" />
154 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Current_Year" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Current Year" SourceColumnNullMapping="false" SourceVersion="Original" />
155 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Mob" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Mob" SourceColumnNullMapping="true" SourceVersion="Original" />
156 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Mob" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mob" SourceColumnNullMapping="false" SourceVersion="Original" />
157 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Email" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
158 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
159 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Password" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
160 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
161 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Test_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Test Date" SourceColumnNullMapping="true" SourceVersion="Original" />
162 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Test_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Test Date" SourceColumnNullMapping="false" SourceVersion="Original" />
163 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Total_Ques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Total_Ques" SourceColumnNullMapping="true" SourceVersion="Original" />
164 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Total_Ques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Total_Ques" SourceColumnNullMapping="false" SourceVersion="Original" />
165 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_hour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="hour" SourceColumnNullMapping="true" SourceVersion="Original" />
166 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_hour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="hour" SourceColumnNullMapping="false" SourceVersion="Original" />
167 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_min" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="min" SourceColumnNullMapping="true" SourceVersion="Original" />
168 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_min" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="min" SourceColumnNullMapping="false" SourceVersion="Original" />
169 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_sec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sec" SourceColumnNullMapping="true" SourceVersion="Original" />
170 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sec" SourceColumnNullMapping="false" SourceVersion="Original" />
171 </Parameters>
172 </DbCommand>
173 </UpdateCommand>
174 </DbSource>
175 </MainSource>
176 <Mappings>
177 <Mapping SourceColumn="RollNo" DataSetColumn="RollNo" />
178 <Mapping SourceColumn="Full Name" DataSetColumn="Full Name" />
179 <Mapping SourceColumn="Dept" DataSetColumn="Dept" />
180 <Mapping SourceColumn="Current Year" DataSetColumn="Current Year" />
181 <Mapping SourceColumn="Mob" DataSetColumn="Mob" />
182 <Mapping SourceColumn="Email" DataSetColumn="Email" />
183 <Mapping SourceColumn="Password" DataSetColumn="Password" />
184 <Mapping SourceColumn="Test Date" DataSetColumn="Test Date" />
185 <Mapping SourceColumn="hour" DataSetColumn="hour" />
186 <Mapping SourceColumn="min" DataSetColumn="min" />
187 <Mapping SourceColumn="sec" DataSetColumn="sec" />
188 <Mapping SourceColumn="Total_Ques" DataSetColumn="Total_Ques" />
189 </Mappings>
190 <Sources />
191 </TableAdapter>
192 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QuesTableAdapter" GeneratorDataComponentClassName="QuesTableAdapter" Name="Ques" UserDataComponentName="QuesTableAdapter">
193 <MainSource>
194 <DbSource ConnectionRef="MainDBConnectionString (MySettings)" DbObjectName="Ques" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
195 <InsertCommand>
196 <DbCommand CommandType="Text" ModifiedByUser="false">
197 <CommandText>INSERT INTO `Ques` (`Question`, `Opt1`, `Opt2`, `Opt3`, `Opt4`, `Answer`, `QuesNo`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
198 <Parameters>
199 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Question" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Question" SourceColumnNullMapping="false" SourceVersion="Current" />
200 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Opt1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Opt1" SourceColumnNullMapping="false" SourceVersion="Current" />
201 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Opt2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Opt2" SourceColumnNullMapping="false" SourceVersion="Current" />
202 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Opt3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Opt3" SourceColumnNullMapping="false" SourceVersion="Current" />
203 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Opt4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Opt4" SourceColumnNullMapping="false" SourceVersion="Current" />
204 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Answer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Answer" SourceColumnNullMapping="false" SourceVersion="Current" />
205 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="QuesNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="QuesNo" SourceColumnNullMapping="false" SourceVersion="Current" />
206 </Parameters>
207 </DbCommand>
208 </InsertCommand>
209 <SelectCommand>
210 <DbCommand CommandType="Text" ModifiedByUser="false">
211 <CommandText>SELECT Question, Opt1, Opt2, Opt3, Opt4, Answer, QuesNo FROM Ques</CommandText>
212 <Parameters />
213 </DbCommand>
214 </SelectCommand>
215 </DbSource>
216 </MainSource>
217 <Mappings>
218 <Mapping SourceColumn="Question" DataSetColumn="Question" />
219 <Mapping SourceColumn="Opt1" DataSetColumn="Opt1" />
220 <Mapping SourceColumn="Opt2" DataSetColumn="Opt2" />
221 <Mapping SourceColumn="Opt3" DataSetColumn="Opt3" />
222 <Mapping SourceColumn="Opt4" DataSetColumn="Opt4" />
223 <Mapping SourceColumn="Answer" DataSetColumn="Answer" />
224 <Mapping SourceColumn="QuesNo" DataSetColumn="QuesNo" />
225 </Mappings>
226 <Sources />
227 </TableAdapter>
228 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ResultTableAdapter" GeneratorDataComponentClassName="ResultTableAdapter" Name="Result" UserDataComponentName="ResultTableAdapter">
229 <MainSource>
230 <DbSource ConnectionRef="MainDBConnectionString (MySettings)" DbObjectName="Result" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
231 <InsertCommand>
232 <DbCommand CommandType="Text" ModifiedByUser="false">
233 <CommandText>INSERT INTO `Result` (`RollNo`, `Name`, `Current_Year`, `Dept`, `Total_Ques`, `Attempted_Ques`, `Right_Answers`, `Marks_Obtained`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
234 <Parameters>
235 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RollNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RollNo" SourceColumnNullMapping="false" SourceVersion="Current" />
236 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
237 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Current_Year" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Current_Year" SourceColumnNullMapping="false" SourceVersion="Current" />
238 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dept" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Dept" SourceColumnNullMapping="false" SourceVersion="Current" />
239 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Total_Ques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Total_Ques" SourceColumnNullMapping="false" SourceVersion="Current" />
240 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Attempted_Ques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Attempted_Ques" SourceColumnNullMapping="false" SourceVersion="Current" />
241 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Right_Answers" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Right_Answers" SourceColumnNullMapping="false" SourceVersion="Current" />
242 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Marks_Obtained" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Marks_Obtained" SourceColumnNullMapping="false" SourceVersion="Current" />
243 </Parameters>
244 </DbCommand>
245 </InsertCommand>
246 <SelectCommand>
247 <DbCommand CommandType="Text" ModifiedByUser="false">
248 <CommandText>SELECT RollNo, Name, Current_Year, Dept, Total_Ques, Attempted_Ques, Right_Answers, Marks_Obtained FROM Result</CommandText>
249 <Parameters />
250 </DbCommand>
251 </SelectCommand>
252 </DbSource>
253 </MainSource>
254 <Mappings>
255 <Mapping SourceColumn="RollNo" DataSetColumn="RollNo" />
256 <Mapping SourceColumn="Name" DataSetColumn="Name" />
257 <Mapping SourceColumn="Current_Year" DataSetColumn="Current_Year" />
258 <Mapping SourceColumn="Dept" DataSetColumn="Dept" />
259 <Mapping SourceColumn="Total_Ques" DataSetColumn="Total_Ques" />
260 <Mapping SourceColumn="Attempted_Ques" DataSetColumn="Attempted_Ques" />
261 <Mapping SourceColumn="Right_Answers" DataSetColumn="Right_Answers" />
262 <Mapping SourceColumn="Marks_Obtained" DataSetColumn="Marks_Obtained" />
263 </Mappings>
264 <Sources />
265 </TableAdapter>
266 </Tables>
267 <Sources />
268 </DataSource>
269 </xs:appinfo>
270 </xs:annotation>
271 <xs:element name="MainDBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="MainDBDataSet" msprop:Generator_UserDSName="MainDBDataSet">
272 <xs:complexType>
273 <xs:choice minOccurs="0" maxOccurs="unbounded">
274 <xs:element name="Admin" msprop:Generator_TableClassName="AdminDataTable" msprop:Generator_TableVarName="tableAdmin" msprop:Generator_RowChangedName="AdminRowChanged" msprop:Generator_TablePropName="Admin" msprop:Generator_RowDeletingName="AdminRowDeleting" msprop:Generator_RowChangingName="AdminRowChanging" msprop:Generator_RowEvHandlerName="AdminRowChangeEventHandler" msprop:Generator_RowDeletedName="AdminRowDeleted" msprop:Generator_RowClassName="AdminRow" msprop:Generator_UserTableName="Admin" msprop:Generator_RowEvArgName="AdminRowChangeEvent">
275 <xs:complexType>
276 <xs:sequence>
277 <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:string" />
278 <xs:element name="Full_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnFull_Name" msprop:Generator_ColumnPropNameInRow="Full_Name" msprop:Generator_ColumnPropNameInTable="Full_NameColumn" msprop:Generator_UserColumnName="Full Name" minOccurs="0">
279 <xs:simpleType>
280 <xs:restriction base="xs:string">
281 <xs:maxLength value="255" />
282 </xs:restriction>
283 </xs:simpleType>
284 </xs:element>
285 <xs:element name="Subject" msprop:Generator_ColumnVarNameInTable="columnSubject" msprop:Generator_ColumnPropNameInRow="Subject" msprop:Generator_ColumnPropNameInTable="SubjectColumn" msprop:Generator_UserColumnName="Subject" minOccurs="0">
286 <xs:simpleType>
287 <xs:restriction base="xs:string">
288 <xs:maxLength value="255" />
289 </xs:restriction>
290 </xs:simpleType>
291 </xs:element>
292 <xs:element name="Mobile" msprop:Generator_ColumnVarNameInTable="columnMobile" msprop:Generator_ColumnPropNameInRow="Mobile" msprop:Generator_ColumnPropNameInTable="MobileColumn" msprop:Generator_UserColumnName="Mobile" type="xs:long" minOccurs="0" />
293 <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
294 <xs:simpleType>
295 <xs:restriction base="xs:string">
296 <xs:maxLength value="255" />
297 </xs:restriction>
298 </xs:simpleType>
299 </xs:element>
300 <xs:element name="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnPropNameInTable="PassColumn" msprop:Generator_UserColumnName="Pass" minOccurs="0">
301 <xs:simpleType>
302 <xs:restriction base="xs:string">
303 <xs:maxLength value="30" />
304 </xs:restriction>
305 </xs:simpleType>
306 </xs:element>
307 </xs:sequence>
308 </xs:complexType>
309 </xs:element>
310 <xs:element name="Student" msprop:Generator_TableClassName="StudentDataTable" msprop:Generator_TableVarName="tableStudent" msprop:Generator_TablePropName="Student" msprop:Generator_RowDeletingName="StudentRowDeleting" msprop:Generator_RowChangingName="StudentRowChanging" msprop:Generator_RowEvHandlerName="StudentRowChangeEventHandler" msprop:Generator_RowDeletedName="StudentRowDeleted" msprop:Generator_UserTableName="Student" msprop:Generator_RowChangedName="StudentRowChanged" msprop:Generator_RowEvArgName="StudentRowChangeEvent" msprop:Generator_RowClassName="StudentRow">
311 <xs:complexType>
312 <xs:sequence>
313 <xs:element name="RollNo" msprop:Generator_ColumnVarNameInTable="columnRollNo" msprop:Generator_ColumnPropNameInRow="RollNo" msprop:Generator_ColumnPropNameInTable="RollNoColumn" msprop:Generator_UserColumnName="RollNo" type="xs:int" />
314 <xs:element name="Full_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnFull_Name" msprop:Generator_ColumnPropNameInRow="Full_Name" msprop:Generator_ColumnPropNameInTable="Full_NameColumn" msprop:Generator_UserColumnName="Full Name" minOccurs="0">
315 <xs:simpleType>
316 <xs:restriction base="xs:string">
317 <xs:maxLength value="536870910" />
318 </xs:restriction>
319 </xs:simpleType>
320 </xs:element>
321 <xs:element name="Dept" msprop:Generator_ColumnVarNameInTable="columnDept" msprop:Generator_ColumnPropNameInRow="Dept" msprop:Generator_ColumnPropNameInTable="DeptColumn" msprop:Generator_UserColumnName="Dept" minOccurs="0">
322 <xs:simpleType>
323 <xs:restriction base="xs:string">
324 <xs:maxLength value="255" />
325 </xs:restriction>
326 </xs:simpleType>
327 </xs:element>
328 <xs:element name="Current_x0020_Year" msprop:Generator_ColumnVarNameInTable="columnCurrent_Year" msprop:Generator_ColumnPropNameInRow="Current_Year" msprop:Generator_ColumnPropNameInTable="Current_YearColumn" msprop:Generator_UserColumnName="Current Year" minOccurs="0">
329 <xs:simpleType>
330 <xs:restriction base="xs:string">
331 <xs:maxLength value="255" />
332 </xs:restriction>
333 </xs:simpleType>
334 </xs:element>
335 <xs:element name="Mob" msprop:Generator_ColumnVarNameInTable="columnMob" msprop:Generator_ColumnPropNameInRow="Mob" msprop:Generator_ColumnPropNameInTable="MobColumn" msprop:Generator_UserColumnName="Mob" minOccurs="0">
336 <xs:simpleType>
337 <xs:restriction base="xs:string">
338 <xs:maxLength value="255" />
339 </xs:restriction>
340 </xs:simpleType>
341 </xs:element>
342 <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
343 <xs:simpleType>
344 <xs:restriction base="xs:string">
345 <xs:maxLength value="255" />
346 </xs:restriction>
347 </xs:simpleType>
348 </xs:element>
349 <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
350 <xs:simpleType>
351 <xs:restriction base="xs:string">
352 <xs:maxLength value="255" />
353 </xs:restriction>
354 </xs:simpleType>
355 </xs:element>
356 <xs:element name="Test_x0020_Date" msprop:Generator_ColumnVarNameInTable="columnTest_Date" msprop:Generator_ColumnPropNameInRow="Test_Date" msprop:Generator_ColumnPropNameInTable="Test_DateColumn" msprop:Generator_UserColumnName="Test Date" type="xs:dateTime" minOccurs="0" />
357 <xs:element name="hour" msprop:Generator_ColumnVarNameInTable="columnhour" msprop:Generator_ColumnPropNameInRow="hour" msprop:Generator_ColumnPropNameInTable="hourColumn" msprop:Generator_UserColumnName="hour" type="xs:int" minOccurs="0" />
358 <xs:element name="min" msprop:Generator_ColumnVarNameInTable="columnmin" msprop:Generator_ColumnPropNameInRow="min" msprop:Generator_ColumnPropNameInTable="minColumn" msprop:Generator_UserColumnName="min" type="xs:int" minOccurs="0" />
359 <xs:element name="sec" msprop:Generator_ColumnVarNameInTable="columnsec" msprop:Generator_ColumnPropNameInRow="sec" msprop:Generator_ColumnPropNameInTable="secColumn" msprop:Generator_UserColumnName="sec" type="xs:int" minOccurs="0" />
360 <xs:element name="Total_Ques" msprop:Generator_ColumnVarNameInTable="columnTotal_Ques" msprop:Generator_ColumnPropNameInRow="Total_Ques" msprop:Generator_ColumnPropNameInTable="Total_QuesColumn" msprop:Generator_UserColumnName="Total_Ques" type="xs:int" minOccurs="0" />
361 </xs:sequence>
362 </xs:complexType>
363 </xs:element>
364 <xs:element name="Ques" msprop:Generator_TableClassName="QuesDataTable" msprop:Generator_TableVarName="tableQues" msprop:Generator_RowChangedName="QuesRowChanged" msprop:Generator_TablePropName="Ques" msprop:Generator_RowDeletingName="QuesRowDeleting" msprop:Generator_RowChangingName="QuesRowChanging" msprop:Generator_RowEvHandlerName="QuesRowChangeEventHandler" msprop:Generator_RowDeletedName="QuesRowDeleted" msprop:Generator_RowClassName="QuesRow" msprop:Generator_UserTableName="Ques" msprop:Generator_RowEvArgName="QuesRowChangeEvent">
365 <xs:complexType>
366 <xs:sequence>
367 <xs:element name="Question" msprop:Generator_ColumnVarNameInTable="columnQuestion" msprop:Generator_ColumnPropNameInRow="Question" msprop:Generator_ColumnPropNameInTable="QuestionColumn" msprop:Generator_UserColumnName="Question" minOccurs="0">
368 <xs:simpleType>
369 <xs:restriction base="xs:string">
370 <xs:maxLength value="536870910" />
371 </xs:restriction>
372 </xs:simpleType>
373 </xs:element>
374 <xs:element name="Opt1" msprop:Generator_ColumnVarNameInTable="columnOpt1" msprop:Generator_ColumnPropNameInRow="Opt1" msprop:Generator_ColumnPropNameInTable="Opt1Column" msprop:Generator_UserColumnName="Opt1" minOccurs="0">
375 <xs:simpleType>
376 <xs:restriction base="xs:string">
377 <xs:maxLength value="255" />
378 </xs:restriction>
379 </xs:simpleType>
380 </xs:element>
381 <xs:element name="Opt2" msprop:Generator_ColumnVarNameInTable="columnOpt2" msprop:Generator_ColumnPropNameInRow="Opt2" msprop:Generator_ColumnPropNameInTable="Opt2Column" msprop:Generator_UserColumnName="Opt2" minOccurs="0">
382 <xs:simpleType>
383 <xs:restriction base="xs:string">
384 <xs:maxLength value="255" />
385 </xs:restriction>
386 </xs:simpleType>
387 </xs:element>
388 <xs:element name="Opt3" msprop:Generator_ColumnVarNameInTable="columnOpt3" msprop:Generator_ColumnPropNameInRow="Opt3" msprop:Generator_ColumnPropNameInTable="Opt3Column" msprop:Generator_UserColumnName="Opt3" minOccurs="0">
389 <xs:simpleType>
390 <xs:restriction base="xs:string">
391 <xs:maxLength value="255" />
392 </xs:restriction>
393 </xs:simpleType>
394 </xs:element>
395 <xs:element name="Opt4" msprop:Generator_ColumnVarNameInTable="columnOpt4" msprop:Generator_ColumnPropNameInRow="Opt4" msprop:Generator_ColumnPropNameInTable="Opt4Column" msprop:Generator_UserColumnName="Opt4" minOccurs="0">
396 <xs:simpleType>
397 <xs:restriction base="xs:string">
398 <xs:maxLength value="255" />
399 </xs:restriction>
400 </xs:simpleType>
401 </xs:element>
402 <xs:element name="Answer" msprop:Generator_ColumnVarNameInTable="columnAnswer" msprop:Generator_ColumnPropNameInRow="Answer" msprop:Generator_ColumnPropNameInTable="AnswerColumn" msprop:Generator_UserColumnName="Answer" minOccurs="0">
403 <xs:simpleType>
404 <xs:restriction base="xs:string">
405 <xs:maxLength value="255" />
406 </xs:restriction>
407 </xs:simpleType>
408 </xs:element>
409 <xs:element name="QuesNo" msprop:Generator_ColumnVarNameInTable="columnQuesNo" msprop:Generator_ColumnPropNameInRow="QuesNo" msprop:Generator_ColumnPropNameInTable="QuesNoColumn" msprop:Generator_UserColumnName="QuesNo" type="xs:int" minOccurs="0" />
410 </xs:sequence>
411 </xs:complexType>
412 </xs:element>
413 <xs:element name="Result" msprop:Generator_TableClassName="ResultDataTable" msprop:Generator_TableVarName="tableResult" msprop:Generator_TablePropName="Result" msprop:Generator_RowDeletingName="ResultRowDeleting" msprop:Generator_RowChangingName="ResultRowChanging" msprop:Generator_RowEvHandlerName="ResultRowChangeEventHandler" msprop:Generator_RowDeletedName="ResultRowDeleted" msprop:Generator_UserTableName="Result" msprop:Generator_RowChangedName="ResultRowChanged" msprop:Generator_RowEvArgName="ResultRowChangeEvent" msprop:Generator_RowClassName="ResultRow">
414 <xs:complexType>
415 <xs:sequence>
416 <xs:element name="RollNo" msprop:Generator_ColumnVarNameInTable="columnRollNo" msprop:Generator_ColumnPropNameInRow="RollNo" msprop:Generator_ColumnPropNameInTable="RollNoColumn" msprop:Generator_UserColumnName="RollNo" type="xs:int" minOccurs="0" />
417 <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
418 <xs:simpleType>
419 <xs:restriction base="xs:string">
420 <xs:maxLength value="255" />
421 </xs:restriction>
422 </xs:simpleType>
423 </xs:element>
424 <xs:element name="Current_Year" msprop:Generator_ColumnVarNameInTable="columnCurrent_Year" msprop:Generator_ColumnPropNameInRow="Current_Year" msprop:Generator_ColumnPropNameInTable="Current_YearColumn" msprop:Generator_UserColumnName="Current_Year" minOccurs="0">
425 <xs:simpleType>
426 <xs:restriction base="xs:string">
427 <xs:maxLength value="255" />
428 </xs:restriction>
429 </xs:simpleType>
430 </xs:element>
431 <xs:element name="Dept" msprop:Generator_ColumnVarNameInTable="columnDept" msprop:Generator_ColumnPropNameInRow="Dept" msprop:Generator_ColumnPropNameInTable="DeptColumn" msprop:Generator_UserColumnName="Dept" minOccurs="0">
432 <xs:simpleType>
433 <xs:restriction base="xs:string">
434 <xs:maxLength value="255" />
435 </xs:restriction>
436 </xs:simpleType>
437 </xs:element>
438 <xs:element name="Total_Ques" msprop:Generator_ColumnVarNameInTable="columnTotal_Ques" msprop:Generator_ColumnPropNameInRow="Total_Ques" msprop:Generator_ColumnPropNameInTable="Total_QuesColumn" msprop:Generator_UserColumnName="Total_Ques" type="xs:int" minOccurs="0" />
439 <xs:element name="Attempted_Ques" msprop:Generator_ColumnVarNameInTable="columnAttempted_Ques" msprop:Generator_ColumnPropNameInRow="Attempted_Ques" msprop:Generator_ColumnPropNameInTable="Attempted_QuesColumn" msprop:Generator_UserColumnName="Attempted_Ques" type="xs:int" minOccurs="0" />
440 <xs:element name="Right_Answers" msprop:Generator_ColumnVarNameInTable="columnRight_Answers" msprop:Generator_ColumnPropNameInRow="Right_Answers" msprop:Generator_ColumnPropNameInTable="Right_AnswersColumn" msprop:Generator_UserColumnName="Right_Answers" type="xs:int" minOccurs="0" />
441 <xs:element name="Marks_Obtained" msprop:Generator_ColumnVarNameInTable="columnMarks_Obtained" msprop:Generator_ColumnPropNameInRow="Marks_Obtained" msprop:Generator_ColumnPropNameInTable="Marks_ObtainedColumn" msprop:Generator_UserColumnName="Marks_Obtained" type="xs:int" minOccurs="0" />
442 </xs:sequence>
443 </xs:complexType>
444 </xs:element>
445 </xs:choice>
446 </xs:complexType>
447 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
448 <xs:selector xpath=".//mstns:Admin" />
449 <xs:field xpath="mstns:ID" />
450 </xs:unique>
451 <xs:unique name="Student_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
452 <xs:selector xpath=".//mstns:Student" />
453 <xs:field xpath="mstns:RollNo" />
454 </xs:unique>
455 <xs:unique name="Ques_Constraint1" msdata:ConstraintName="Constraint1">
456 <xs:selector xpath=".//mstns:Ques" />
457 <xs:field xpath="mstns:QuesNo" />
458 </xs:unique>
459 </xs:element>
460 </xs:schema>
